Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	42307
Missing cells	1771
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.8 MiB
Average record size in memory	168.0 B

Variable types

Numeric	7
Categorical	5
DateTime	2
Text	6

Alerts

`LowDoc` is highly imbalanced (63.8%)	Imbalance
`MIS_Status` is highly imbalanced (50.8%)	Imbalance
`RevLineCr` has 1079 (2.6%) missing values	Missing
`LowDoc` has 531 (1.3%) missing values	Missing
`NoEmp` has 2994 (7.1%) zeros	Zeros
`CreateJob` has 28889 (68.3%) zeros	Zeros
`RetainedJob` has 26056 (61.6%) zeros	Zeros
`FranchiseCode` has 26392 (62.4%) zeros	Zeros
`Sector` has 9798 (23.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-21 05:22:43.484443
Analysis finished	2024-01-21 05:22:59.672314
Duration	16.19 seconds
Software version	ydata-profiling vv4.6.3
Download configuration	config.json

Term
Real number (ℝ)

Distinct	228
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.60167

Minimum	0
Maximum	360
Zeros	94
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	56
median	82
Q3	168
95-th percentile	293
Maximum	360
Range	360
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	84.569847
Coefficient of variation (CV)	0.77871587
Kurtosis	-0.28186028
Mean	108.60167
Median Absolute Deviation (MAD)	30
Skewness	1.0246757
Sum	4594611
Variance	7152.0589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	3649	8.6%
83	2863	6.8%
84	1546	3.7%
57	1325	3.1%
81	1300	3.1%
58	1295	3.1%
59	1161	2.7%
56	1046	2.5%
240	892	2.1%
241	875	2.1%
Other values (218)	26355	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.2%
1	54	0.1%
2	75	0.2%
3	62	0.1%
4	91	0.2%
5	140	0.3%
6	145	0.3%
7	158	0.4%
8	188	0.4%
9	232	0.5%

Value	Count	Frequency (%)
360	1	< 0.1%
325	7	< 0.1%
312	11	< 0.1%
311	22	0.1%
310	19	< 0.1%
309	45	0.1%
308	69	0.2%
306	72	0.2%
303	122	0.3%
302	130	0.3%

NoEmp
Real number (ℝ)

ZEROS

Distinct	196
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.7043043

Minimum	0
Maximum	202
Zeros	2994
Zeros (%)	7.1%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	12
95-th percentile	40
Maximum	202
Range	202
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	17.488022
Coefficient of variation (CV)	1.8020892
Kurtosis	40.742751
Mean	9.7043043
Median Absolute Deviation (MAD)	3
Skewness	5.4942159
Sum	410560
Variance	305.83092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5563	13.1%
2	5518	13.0%
4	4902	11.6%
1	4433	10.5%
5	3146	7.4%
0	2994	7.1%
6	1691	4.0%
15	975	2.3%
16	914	2.2%
7	901	2.1%
Other values (186)	11270	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2994	7.1%
1	4433	10.5%
2	5518	13.0%
3	5563	13.1%
4	4902	11.6%
5	3146	7.4%
6	1691	4.0%
7	901	2.1%
8	602	1.4%
9	544	1.3%

Value	Count	Frequency (%)
202	1	< 0.1%
198	1	< 0.1%
197	2	< 0.1%
195	1	< 0.1%
194	2	< 0.1%
193	2	< 0.1%
192	2	< 0.1%
191	3	< 0.1%
189	3	< 0.1%
188	2	< 0.1%

NewExist
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

1.0	33405
2.0	8902

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	126921
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Most occurring characters

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	84614	66.7%
Other Punctuation	42307	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	42307	50.0%
1	33405	39.5%
2	8902	10.5%

Other Punctuation

Value	Count	Frequency (%)
.	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126921	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126921	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

CreateJob
Real number (ℝ)

ZEROS

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1837285

Minimum	0
Maximum	70
Zeros	28889
Zeros (%)	68.3%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	70
Range	70
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.0939801
Coefficient of variation (CV)	2.3326985
Kurtosis	23.628207
Mean	2.1837285
Median Absolute Deviation (MAD)	0
Skewness	4.0134768
Sum	92387
Variance	25.948633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	28889	68.3%
3	3293	7.8%
1	2519	6.0%
4	1334	3.2%
8	665	1.6%
9	579	1.4%
2	548	1.3%
10	511	1.2%
7	484	1.1%
11	448	1.1%
Other values (39)	3037	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28889	68.3%
1	2519	6.0%
2	548	1.3%
3	3293	7.8%
4	1334	3.2%
5	73	0.2%
6	250	0.6%
7	484	1.1%
8	665	1.6%
9	579	1.4%

Value	Count	Frequency (%)
70	1	< 0.1%
60	3	< 0.1%
57	5	< 0.1%
56	5	< 0.1%
50	6	< 0.1%
48	12	< 0.1%
47	15	< 0.1%
46	19	< 0.1%
45	16	< 0.1%
40	17	< 0.1%

RetainedJob
Real number (ℝ)

ZEROS

Distinct	83
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4781478

Minimum	0
Maximum	140
Zeros	26056
Zeros (%)	61.6%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	15
Maximum	140
Range	140
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	8.1136484
Coefficient of variation (CV)	2.3327497
Kurtosis	40.299963
Mean	3.4781478
Median Absolute Deviation (MAD)	0
Skewness	5.1823038
Sum	147150
Variance	65.83129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
8	1227	2.9%
9	1060	2.5%
3	1057	2.5%
7	986	2.3%
10	837	2.0%
2	803	1.9%
11	795	1.9%
12	769	1.8%
Other values (73)	4871	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
2	803	1.9%
3	1057	2.5%
4	687	1.6%
5	329	0.8%
6	575	1.4%
7	986	2.3%
8	1227	2.9%
9	1060	2.5%

Value	Count	Frequency (%)
140	1	< 0.1%
136	1	< 0.1%
130	1	< 0.1%
118	1	< 0.1%
102	2	< 0.1%
100	4	< 0.1%
95	4	< 0.1%
91	7	< 0.1%
90	6	< 0.1%
87	7	< 0.1%

FranchiseCode
Real number (ℝ)

ZEROS

Distinct	271
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1955.056

Minimum	0
Maximum	90709
Zeros	26392
Zeros (%)	62.4%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	90709
Range	90709
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	10541.389
Coefficient of variation (CV)	5.3918602
Kurtosis	35.690306
Mean	1955.056
Median Absolute Deviation (MAD)	0
Skewness	5.919311
Sum	82712555
Variance	1.1112088 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
27760	21	< 0.1%
74750	20	< 0.1%
72590	18	< 0.1%
73000	18	< 0.1%
73675	15	< 0.1%
34850	15	< 0.1%
36680	14	< 0.1%
Other values (261)	1579	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
5725	1	< 0.1%
6410	1	< 0.1%
9120	1	< 0.1%
9450	1	< 0.1%
10482	1	< 0.1%
10494	1	< 0.1%
10528	3	< 0.1%

Value	Count	Frequency (%)
90709	1	< 0.1%
89769	2	< 0.1%
89655	1	< 0.1%
89640	2	< 0.1%
89352	1	< 0.1%
89350	1	< 0.1%
88875	2	< 0.1%
88355	1	< 0.1%
87350	3	< 0.1%
86720	3	< 0.1%

RevLineCr
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1079
Missing (%)	2.6%
Memory size	661.0 KiB

N	27618
Y	7353
0	5561
T	696

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41228
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	0
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	27618	65.3%
Y	7353	17.4%
0	5561	13.1%
T	696	1.6%
(Missing)	1079	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	27618	67.0%
y	7353	17.8%
0	5561	13.5%
t	696	1.7%

Most occurring characters

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35667	86.5%
Decimal Number	5561	13.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Decimal Number

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35667	86.5%
Common	5561	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Common

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41228	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

LowDoc
Categorical

IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	531
Missing (%)	1.3%
Memory size	661.0 KiB

N	34313
Y	5277
0	684
A	570
S	540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41776
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	34313	81.1%
Y	5277	12.5%
0	684	1.6%
A	570	1.3%
S	540	1.3%
C	392	0.9%
(Missing)	531	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	34313	82.1%
y	5277	12.6%
0	684	1.6%
a	570	1.4%
s	540	1.3%
c	392	0.9%

Most occurring characters

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41092	98.4%
Decimal Number	684	1.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Decimal Number

Value	Count	Frequency (%)
0	684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41092	98.4%
Common	684	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Common

Value	Count	Frequency (%)
0	684	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41776	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

DisbursementDate
Date

Distinct	916
Distinct (%)	2.2%
Missing	150
Missing (%)	0.4%
Memory size	661.0 KiB

Minimum	1977-06-14 00:00:00
Maximum	2073-12-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

MIS_Status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

1	37767
0	4540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring characters

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Sector
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.933439

Minimum	0
Maximum	81
Zeros	9798
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	33
Q3	44
95-th percentile	72
Maximum	81
Range	81
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	22.291386
Coefficient of variation (CV)	0.67686178
Kurtosis	-0.89972227
Mean	32.933439
Median Absolute Deviation (MAD)	11
Skewness	-0.11631806
Sum	1393315
Variance	496.90589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	9798	23.2%
42	7337	17.3%
33	5050	11.9%
44	3868	9.1%
23	3867	9.1%
61	2505	5.9%
72	2478	5.9%
22	1998	4.7%
62	1191	2.8%
53	896	2.1%
Other values (14)	3319	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9798	23.2%
11	7	< 0.1%
21	28	0.1%
22	1998	4.7%
23	3867	9.1%
31	138	0.3%
32	865	2.0%
33	5050	11.9%
42	7337	17.3%
44	3868	9.1%

Value	Count	Frequency (%)
81	169	0.4%
72	2478	5.9%
71	337	0.8%
62	1191	2.8%
61	2505	5.9%
56	672	1.6%
55	29	0.1%
54	267	0.6%
53	896	2.1%
52	84	0.2%

ApprovalDate
Date

Distinct	3868
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Minimum	1977-03-11 00:00:00
Maximum	2073-10-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ApprovalFY
Real number (ℝ)

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.5378

Minimum	1974
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	1974
5-th percentile	1991
Q1	1997
median	2003
Q3	2006
95-th percentile	2010
Maximum	2014
Range	40
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.8605268
Coefficient of variation (CV)	0.0029280121
Kurtosis	0.16185187
Mean	2001.5378
Median Absolute Deviation (MAD)	4
Skewness	-0.69419236
Sum	84679059
Variance	34.345775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
2004	4708	11.1%
2007	3777	8.9%
2006	3314	7.8%
2003	3293	7.8%
2005	2712	6.4%
1995	2552	6.0%
2000	2295	5.4%
1996	1739	4.1%
2002	1726	4.1%
2008	1723	4.1%
Other values (28)	14468	34.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1974	4	< 0.1%
1977	5	< 0.1%
1979	21	< 0.1%
1980	56	0.1%
1981	13	< 0.1%
1982	78	0.2%
1983	80	0.2%
1984	79	0.2%
1985	134	0.3%
1986	77	0.2%

Value	Count	Frequency (%)
2014	9	< 0.1%
2013	105	0.2%
2012	318	0.8%
2011	781	1.8%
2010	948	2.2%
2009	1158	2.7%
2008	1723	4.1%
2007	3777	8.9%
2006	3314	7.8%
2005	2712	6.4%

City
Text

Distinct	2703
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	30
Median length	27
Mean length	8.8926892
Min length	3

Characters and Unicode

Total characters	376223
Distinct characters	65
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	827 ?
Unique (%)	2.0%

Sample

1st row	PHOENIX
2nd row	MCALESTER
3rd row	HAWTHORNE
4th row	NASHVILLE
5th row	POMONA

Value	Count	Frequency (%)
city	1492	2.7%
san	1325	2.4%
houston	1224	2.3%
pittsburgh	958	1.8%
lake	812	1.5%
salt	716	1.3%
new	616	1.1%
philadelphia	614	1.1%
nashville	600	1.1%
pomona	584	1.1%
Other values (2347)	45399	83.5%

Most occurring characters

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	353936	94.1%
Space Separator	12034	3.2%
Lowercase Letter	9453	2.5%
Other Punctuation	370	0.1%
Open Punctuation	262	0.1%
Close Punctuation	151	< 0.1%
Decimal Number	10	< 0.1%
Dash Punctuation	6	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	36799	10.4%
E	32773	9.3%
O	29514	8.3%
L	29423	8.3%
N	28734	8.1%
I	24008	6.8%
S	23939	6.8%
R	22162	6.3%
T	20421	5.8%
C	13141	3.7%
Other values (16)	93022	26.3%

Lowercase Letter

Value	Count	Frequency (%)
o	1044	11.0%
e	998	10.6%
a	940	9.9%
n	940	9.9%
l	873	9.2%
r	813	8.6%
i	696	7.4%
s	567	6.0%
t	499	5.3%
u	258	2.7%
Other values (16)	1825	19.3%

Decimal Number

Value	Count	Frequency (%)
6	2	20.0%
8	2	20.0%
5	2	20.0%
0	2	20.0%
2	2	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	271	73.2%
'	59	15.9%
,	40	10.8%

Space Separator

Value	Count	Frequency (%)
	12034	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	262	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	151	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363389	96.6%
Common	12834	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	36799	10.1%
E	32773	9.0%
O	29514	8.1%
L	29423	8.1%
N	28734	7.9%
I	24008	6.6%
S	23939	6.6%
R	22162	6.1%
T	20421	5.6%
C	13141	3.6%
Other values (42)	102475	28.2%

Common

Value	Count	Frequency (%)
	12034	93.8%
.	271	2.1%
(	262	2.0%
)	151	1.2%
'	59	0.5%
,	40	0.3%
-	6	< 0.1%
6	2	< 0.1%
8	2	< 0.1%
5	2	< 0.1%
Other values (3)	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

State
Text

Distinct	51
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84614
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AZ
2nd row	OK
3rd row	NJ
4th row	TN
5th row	CA

Value	Count	Frequency (%)
ca	6893	16.3%
tx	4095	9.7%
ny	2953	7.0%
pa	2849	6.7%
fl	1920	4.5%
oh	1229	2.9%
ut	1166	2.8%
tn	1147	2.7%
wa	1050	2.5%
mn	1004	2.4%
Other values (41)	18001	42.5%

Most occurring characters

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84614	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84614	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

BankState
Text

Distinct	51
Distinct (%)	0.1%
Missing	11
Missing (%)	< 0.1%
Memory size	661.0 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84592
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SD
2nd row	OK
3rd row	NJ
4th row	SD
5th row	CA

Value	Count	Frequency (%)
ca	6476	15.3%
nc	3320	7.8%
il	2944	7.0%
oh	2785	6.6%
ri	2541	6.0%
tx	2457	5.8%
sd	2382	5.6%
ny	2197	5.2%
pa	1307	3.1%
ut	1133	2.7%
Other values (41)	14754	34.9%

Most occurring characters

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84592	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84592	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

DisbursementGross
Text

Distinct	2694
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	14
Median length	12
Mean length	11.495237
Min length	10

Characters and Unicode

Total characters	486329
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	685 ?
Unique (%)	1.6%

Sample

1st row	$80,000.00
2nd row	$287,000.00
3rd row	$31,983.00
4th row	$229,000.00
5th row	$525,000.00

Value	Count	Frequency (%)
100,000.00	2773	6.6%
50,000.00	2016	4.8%
25,000.00	1433	3.4%
5,000.00	1298	3.1%
60,000.00	1041	2.5%
150,000.00	971	2.3%
80,000.00	955	2.3%
145,000.00	773	1.8%
17,000.00	729	1.7%
10,000.00	690	1.6%
Other values (2684)	29628	70.0%

Most occurring characters

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	316185	65.0%
Other Punctuation	85530	17.6%
Currency Symbol	42307	8.7%
Space Separator	42307	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	217564	68.8%
5	20651	6.5%
1	18647	5.9%
2	13317	4.2%
3	9574	3.0%
4	8893	2.8%
7	7929	2.5%
6	7457	2.4%
8	6532	2.1%
9	5621	1.8%

Other Punctuation

Value	Count	Frequency (%)
,	43223	50.5%
.	42307	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	486329	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	486329	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

GrAppv
Text

Distinct	1425
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	14
Median length	12
Mean length	11.469662
Min length	10

Characters and Unicode

Total characters	485247
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	294 ?
Unique (%)	0.7%

Sample

1st row	$80,000.00
2nd row	$287,000.00
3rd row	$30,000.00
4th row	$229,000.00
5th row	$525,000.00

Value	Count	Frequency (%)
100,000.00	3257	7.7%
50,000.00	2934	6.9%
25,000.00	2153	5.1%
5,000.00	1426	3.4%
10,000.00	1330	3.1%
60,000.00	1088	2.6%
150,000.00	1051	2.5%
80,000.00	988	2.3%
15,000.00	905	2.1%
20,000.00	902	2.1%
Other values (1415)	26273	62.1%

Most occurring characters

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	315092	64.9%
Other Punctuation	85541	17.6%
Currency Symbol	42307	8.7%
Space Separator	42307	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	234078	74.3%
5	20609	6.5%
1	16194	5.1%
2	11923	3.8%
3	7367	2.3%
4	6360	2.0%
7	5694	1.8%
6	5310	1.7%
8	4480	1.4%
9	3077	1.0%

Other Punctuation

Value	Count	Frequency (%)
,	43234	50.5%
.	42307	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	485247	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	485247	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

SBA_Appv
Text

Distinct	2005
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	14
Median length	11
Mean length	11.284374
Min length	10

Characters and Unicode

Total characters	477408
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	443 ?
Unique (%)	1.0%

Sample

1st row	$68,000.00
2nd row	$229,600.00
3rd row	$15,000.00
4th row	$229,000.00
5th row	$393,750.00

Value	Count	Frequency (%)
25,000.00	2382	5.6%
12,500.00	1705	4.0%
90,000.00	1023	2.4%
4,250.00	985	2.3%
50,000.00	982	2.3%
5,000.00	957	2.3%
116,000.00	757	1.8%
51,000.00	742	1.8%
80,000.00	729	1.7%
13,600.00	715	1.7%
Other values (1995)	31330	74.1%

Most occurring characters

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	307751	64.5%
Other Punctuation	85043	17.8%
Currency Symbol	42307	8.9%
Space Separator	42307	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	192470	62.5%
5	28769	9.3%
2	18959	6.2%
1	18682	6.1%
3	9861	3.2%
7	9728	3.2%
6	8048	2.6%
4	7649	2.5%
8	7052	2.3%
9	6533	2.1%

Other Punctuation

Value	Count	Frequency (%)
,	42736	50.3%
.	42307	49.7%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	477408	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477408	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

UrbanRural
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

0	24037
1	11759
2	6511

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring characters

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
0	163	21	1.0	0	0	1	N	N	31-Jan-98	1	0	22-Sep-06	2006	PHOENIX	AZ	SD	$80,000.00	$80,000.00	$68,000.00	0
1	84	6	1.0	4	0	0	0	N	31-Oct-93	1	62	30-Jun-92	1992	MCALESTER	OK	OK	$287,000.00	$287,000.00	$229,600.00	0
2	242	45	1.0	4	90	0	N	N	31-Aug-01	1	42	18-Apr-01	2001	HAWTHORNE	NJ	NJ	$31,983.00	$30,000.00	$15,000.00	1
3	237	4	1.0	0	0	0	N	N	31-Aug-07	1	33	6-Oct-03	2004	NASHVILLE	TN	SD	$229,000.00	$229,000.00	$229,000.00	0
4	184	0	1.0	0	0	0	N	N	8-Jun-83	1	0	17-Dec-99	2000	POMONA	CA	CA	$525,000.00	$525,000.00	$393,750.00	0
5	60	7	1.0	4	10	0	Y	N	1-Apr-12	0	44	26-Nov-93	1994	APLINGTON	IA	IA	$69,991.00	$70,000.00	$35,000.00	0
6	39	0	1.0	15	1	0	0	N	8-Nov-11	1	23	4-Jan-05	2005	DALLAS	TX	CA	$50,000.00	$50,000.00	$25,000.00	0
7	82	5	2.0	0	0	1	N	C	31-Jan-95	1	0	21-Nov-01	2002	HUDSON	NH	NH	$414,000.00	$414,000.00	$414,000.00	0
8	57	6	2.0	0	0	0	N	C	31-Jan-95	1	61	11-Jan-95	1995	WILLISTON	ND	ND	$112,500.00	$112,500.00	$101,250.00	0
9	25	1	1.0	0	0	1	N	N	30-Apr-07	1	0	23-Mar-04	2004	MESA	AZ	AZ	$50,000.00	$50,000.00	$25,000.00	2

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
42297	57	2	1.0	0	0	960	N	N	29-Jun-01	1	0	8-Mar-96	1996	SACRAMENTO	CA	CO	$105,000.00	$105,000.00	$89,250.00	0
42298	82	15	1.0	1	10	72590	0	N	30-Apr-06	1	44	15-May-03	2003	DALLAS	TX	TX	$50,000.00	$50,000.00	$25,000.00	0
42299	10	2	1.0	0	1	0	Y	N	30-Jun-08	0	72	8-Mar-00	2000	CLARENCE	NY	NY	$670,000.00	$670,000.00	$670,000.00	1
42300	82	3	1.0	0	0	1	N	N	31-Dec-05	1	42	9-Jul-03	2003	NEW YORK	NY	IL	$150,000.00	$150,000.00	$135,000.00	0
42301	82	0	1.0	18	1	1	Y	N	10-Dec-96	1	23	7-Jul-09	2009	PITTSBURGH	PA	PA	$5,000.00	$5,000.00	$4,250.00	1
42302	283	14	1.0	0	0	1	N	N	31-Jan-98	1	0	2-Mar-95	1995	PHILADELPHIA	PA	PA	$80,000.00	$80,000.00	$68,000.00	0
42303	53	2	1.0	0	0	0	Y	N	3-Apr-91	1	42	6-Jun-07	2007	LOS ANGELES	CA	SD	$5,000.00	$5,000.00	$4,250.00	1
42304	59	6	2.0	0	0	1	N	N	28-Feb-03	1	42	14-Mar-03	2003	COLUMBUS	OH	OH	$60,000.00	$60,000.00	$51,000.00	0
42305	295	18	1.0	0	8	0	N	N	10-Dec-97	1	42	23-Aug-89	1989	CLOQUET	MN	MN	$294,000.00	$294,000.00	$220,500.00	0
42306	84	4	1.0	0	8	0	N	N	31-Oct-89	1	72	12-Apr-11	2011	SAN GABRIEL	CA	NC	$67,500.00	$67,500.00	$50,625.00	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories